USE master;
GO

-- backup with 1 file
BACKUP DATABASE <database_name>
TO DISK = N'C:\MSSQL\Backup\<database_name>_Full.bak',
WITH Name = '<database_name> Full 1 File',
INIT, STATS = 10;

-- backup with 2 files
BACKUP DATABASE <database_name>
TO DISK = N'C:\MSSQL\Backup\<database_name>_Full_1.bak',
DISK = N'D:\MSSQL\Backup\<database_name>_Full_2.bak'
WITH Name = '<database_name> Full 2 Files',
INIT, STATS = 10;

-- restore
RESTORE DATABASE <database_name>
FROM DISK = N'C:\MSSQL\Backup\<database_name>_Full_1.bak', 
DISK = N'D:\MSSQL\Backup\<database_name>_Full_2.bak'
WITH NORECOVERY;

-- recover the database
RESTORE DATABASE <database_name> WITH RECOVERY;

-- backup a database to 4 files setting the buffer count and maximum transfer size
EXECUTE dbo.DatabaseBackup
@Databases = '<database_name>',
@Directory = 'D:\MSSQL\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@CheckSum = 'Y',
@BufferCount = 50,
@MaxTransferSize = 4194304,
@NumberOfFiles = 4;